insert overwrite table jms_dwd.dwd_yl_tmsnew_tms_shipment_base_hf partition (dt)
select
     id
    ,shipment_no
    ,vehicleline_type
    ,business_attribute
    ,shipment_name
    ,vehicleline_id
    ,vehicleline_code
    ,vehicleline_name
    ,shifts
    ,transport_type
    ,operation_model
    ,vehicle_groupid
    ,vehicle_typegroup
    ,start_id
    ,start_code
    ,start_name
    ,end_id
    ,end_code
    ,end_name
    ,cnt
    ,mileage
    ,total_runtime
    ,total_intransittime
    ,span_days
    ,standard_speed
    ,planned_departure_time
    ,planned_arrival_time
    ,actual_departure_time
    ,actual_arrival_time
    ,shipment_state
    ,apply_reason
    ,audit_status
    ,audit_remark
    ,audit_id
    ,auditer
    ,audit_date
    ,vehicle_class_id
    ,vehicle_class_name
    ,plate_number
    ,trailer_number
    ,carrier_id
    ,carrier_type
    ,carrier_name
    ,vehicletype_id
    ,vehicletype_name
    ,load_weight
    ,vehicle_door_cnt
    ,driver_name
    ,driver_contact
    ,shipment_type
    ,quotation_model
    ,create_by
    ,create_by_name
    ,create_time
    ,update_by
    ,update_by_name
    ,update_time
    ,apply_reason_item
    ,pic_path
    ,pic_adr
    ,promotion
    ,overtime_type
    ,overtime_reasons
    ,ori_reg_shift_carrier_id
    ,freight_generate_status
    ,billing_way
    ,settlement_vehicle_type_id
    ,settlement_vehicle_type_name
    ,car_apply_code
    ,bidding_demand_code
    ,is_ballast
    ,special_vehicle_type_id
    ,special_vehicle_type_name
    ,dt
from jms_ods.yl_tmsnew_tms_shipment_hf
where dt = '{{ execution_date | cst_hour }}';